﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DocsRoomManagementDataSet" targetNamespace="http://tempuri.org/DocsRoomManagementDataSet.xsd" xmlns:mstns="http://tempuri.org/DocsRoomManagementDataSet.xsd" xmlns="http://tempuri.org/DocsRoomManagementDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DocsRoomManagementConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DocsRoomManagementConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ConsoleApplication2.Properties.Settings.GlobalReference.Default.DocsRoomManagementConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CityTableAdapter" GeneratorDataComponentClassName="CityTableAdapter" Name="City" UserDataComponentName="CityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.City" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[City] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[City] ([Id], [Name]) VALUES (@Id, @Name);
SELECT Id, Name FROM City WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Name FROM dbo.City</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[City] SET [Id] = @Id, [Name] = @Name WHERE (([Id] = @Original_Id));
SELECT Id, Name FROM City WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Geo_DataTableAdapter" GeneratorDataComponentClassName="Geo_DataTableAdapter" Name="Geo_Data" UserDataComponentName="Geo_DataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Geo_Data" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Geo_Data] WHERE (([Id] = @Original_Id) AND ([Xaxis] = @Original_Xaxis) AND ([Yaxis] = @Original_Yaxis))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Xaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Xaxis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Yaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Yaxis" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Geo_Data] ([Id], [Xaxis], [Yaxis]) VALUES (@Id, @Xaxis, @Yaxis);
SELECT Id, Xaxis, Yaxis FROM Geo_Data WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Xaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Xaxis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Yaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Yaxis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Xaxis, Yaxis FROM dbo.Geo_Data</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Geo_Data] SET [Id] = @Id, [Xaxis] = @Xaxis, [Yaxis] = @Yaxis WHERE (([Id] = @Original_Id) AND ([Xaxis] = @Original_Xaxis) AND ([Yaxis] = @Original_Yaxis));
SELECT Id, Xaxis, Yaxis FROM Geo_Data WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Xaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Xaxis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Yaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Yaxis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Xaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Xaxis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Yaxis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Yaxis" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Xaxis" DataSetColumn="Xaxis" />
              <Mapping SourceColumn="Yaxis" DataSetColumn="Yaxis" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PictureTableAdapter" GeneratorDataComponentClassName="PictureTableAdapter" Name="Picture" UserDataComponentName="PictureTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Picture" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Picture] WHERE (([Id] = @Original_Id) AND ((@IsNull_RentalID = 1 AND [RentalID] IS NULL) OR ([RentalID] = @Original_RentalID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Picture] ([Name], [RentalID], [FileName]) VALUES (@Name, @RentalID, @FileName);
SELECT Id, Name, RentalID, FileName FROM Picture WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@FileName" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Name, RentalID, FileName FROM dbo.Picture</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Picture] SET [Name] = @Name, [RentalID] = @RentalID, [FileName] = @FileName WHERE (([Id] = @Original_Id) AND ((@IsNull_RentalID = 1 AND [RentalID] IS NULL) OR ([RentalID] = @Original_RentalID)));
SELECT Id, Name, RentalID, FileName FROM Picture WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@FileName" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="DocsRoomManagement.dbo.Picture" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="RentalID" DataSetColumn="RentalID" />
              <Mapping SourceColumn="FileName" DataSetColumn="FileName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RentalTableAdapter" GeneratorDataComponentClassName="RentalTableAdapter" Name="Rental" UserDataComponentName="RentalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Rental" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Rental] WHERE (([Id] = @Original_Id) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_Room = 1 AND [Room] IS NULL) OR ([Room] = @Original_Room)) AND ((@IsNull_YearOfConstruction = 1 AND [YearOfConstruction] IS NULL) OR ([YearOfConstruction] = @Original_YearOfConstruction)) AND ((@IsNull_RegistrationDate = 1 AND [RegistrationDate] IS NULL) OR ([RegistrationDate] = @Original_RegistrationDate)) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)) AND ((@IsNull_UserId = 1 AND [UserId] IS NULL) OR ([UserId] = @Original_UserId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RegistrationDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RegistrationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Rental] ([Id], [Price], [Room], [YearOfConstruction], [Zip_Code], [What], [Description], [RegistrationDate], [CityID], [UserId]) VALUES (@Id, @Price, @Room, @YearOfConstruction, @Zip_Code, @What, @Description, @RegistrationDate, @CityID, @UserId);
SELECT Id, Price, Room, YearOfConstruction, Zip_Code, What, Description, RegistrationDate, CityID, UserId FROM Rental WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zip_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@What" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="What" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RegistrationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Price, Room, YearOfConstruction, Zip_Code, What, Description, RegistrationDate, CityID, UserId FROM dbo.Rental</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Rental] SET [Id] = @Id, [Price] = @Price, [Room] = @Room, [YearOfConstruction] = @YearOfConstruction, [Zip_Code] = @Zip_Code, [What] = @What, [Description] = @Description, [RegistrationDate] = @RegistrationDate, [CityID] = @CityID, [UserId] = @UserId WHERE (([Id] = @Original_Id) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_Room = 1 AND [Room] IS NULL) OR ([Room] = @Original_Room)) AND ((@IsNull_YearOfConstruction = 1 AND [YearOfConstruction] IS NULL) OR ([YearOfConstruction] = @Original_YearOfConstruction)) AND ((@IsNull_RegistrationDate = 1 AND [RegistrationDate] IS NULL) OR ([RegistrationDate] = @Original_RegistrationDate)) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)) AND ((@IsNull_UserId = 1 AND [UserId] IS NULL) OR ([UserId] = @Original_UserId)));
SELECT Id, Price, Room, YearOfConstruction, Zip_Code, What, Description, RegistrationDate, CityID, UserId FROM Rental WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Zip_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Zip_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@What" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="What" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RegistrationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Room" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Room" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_YearOfConstruction" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YearOfConstruction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RegistrationDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RegistrationDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RegistrationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="Room" DataSetColumn="Room" />
              <Mapping SourceColumn="YearOfConstruction" DataSetColumn="YearOfConstruction" />
              <Mapping SourceColumn="Zip_Code" DataSetColumn="Zip_Code" />
              <Mapping SourceColumn="What" DataSetColumn="What" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="RegistrationDate" DataSetColumn="RegistrationDate" />
              <Mapping SourceColumn="CityID" DataSetColumn="CityID" />
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StreetTableAdapter" GeneratorDataComponentClassName="StreetTableAdapter" Name="Street" UserDataComponentName="StreetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Street" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Street] WHERE (([Id] = @Original_Id) AND ((@IsNull_Nr = 1 AND [Nr] IS NULL) OR ([Nr] = @Original_Nr)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Street] ([Id], [Name], [Nr], [File]) VALUES (@Id, @Name, @Nr, @File);
SELECT Id, Name, Nr, [File] FROM Street WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@File" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="File" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Name, Nr, [File] FROM dbo.Street</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Street] SET [Id] = @Id, [Name] = @Name, [Nr] = @Nr, [File] = @File WHERE (([Id] = @Original_Id) AND ((@IsNull_Nr = 1 AND [Nr] IS NULL) OR ([Nr] = @Original_Nr)));
SELECT Id, Name, Nr, [File] FROM Street WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@File" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="File" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Nr" DataSetColumn="Nr" />
              <Mapping SourceColumn="File" DataSetColumn="File" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Street_Map_CityTableAdapter" GeneratorDataComponentClassName="Street_Map_CityTableAdapter" Name="Street_Map_City" UserDataComponentName="Street_Map_CityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Street_Map_City" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Street_Map_City] WHERE (([StreetId] = @Original_StreetId) AND ([CityId] = @Original_CityId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StreetId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StreetId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Street_Map_City] ([StreetId], [CityId]) VALUES (@StreetId, @CityId);
SELECT StreetId, CityId FROM Street_Map_City WHERE (CityId = @CityId) AND (StreetId = @StreetId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StreetId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StreetId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT StreetId, CityId FROM dbo.Street_Map_City</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Street_Map_City] SET [StreetId] = @StreetId, [CityId] = @CityId WHERE (([StreetId] = @Original_StreetId) AND ([CityId] = @Original_CityId));
SELECT StreetId, CityId FROM Street_Map_City WHERE (CityId = @CityId) AND (StreetId = @StreetId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StreetId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StreetId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StreetId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StreetId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StreetId" DataSetColumn="StreetId" />
              <Mapping SourceColumn="CityId" DataSetColumn="CityId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([Id], [First_Name], [Last_Name], [RegisterSince], [Password], [Tel_number], [UserGroup], [CityId], [WishListId]) VALUES (@Id, @First_Name, @Last_Name, @RegisterSince, @Password, @Tel_number, @UserGroup, @CityId, @WishListId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Last_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Last_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RegisterSince" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RegisterSince" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Tel_number" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Tel_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WishListId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WishListId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, First_Name, Last_Name, RegisterSince, Password, Tel_number, UserGroup, CityId, WishListId FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="First_Name" DataSetColumn="First_Name" />
              <Mapping SourceColumn="Last_Name" DataSetColumn="Last_Name" />
              <Mapping SourceColumn="RegisterSince" DataSetColumn="RegisterSince" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Tel_number" DataSetColumn="Tel_number" />
              <Mapping SourceColumn="UserGroup" DataSetColumn="UserGroup" />
              <Mapping SourceColumn="CityId" DataSetColumn="CityId" />
              <Mapping SourceColumn="WishListId" DataSetColumn="WishListId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WishListTableAdapter" GeneratorDataComponentClassName="WishListTableAdapter" Name="WishList" UserDataComponentName="WishListTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.WishList" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[WishList] WHERE (([Id] = @Original_Id) AND ((@IsNull_RentalID = 1 AND [RentalID] IS NULL) OR ([RentalID] = @Original_RentalID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[WishList] ([Id], [RentalID]) VALUES (@Id, @RentalID);
SELECT Id, RentalID FROM WishList WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, RentalID FROM dbo.WishList</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[WishList] SET [Id] = @Id, [RentalID] = @RentalID WHERE (([Id] = @Original_Id) AND ((@IsNull_RentalID = 1 AND [RentalID] IS NULL) OR ([RentalID] = @Original_RentalID)));
SELECT Id, RentalID FROM WishList WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RentalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RentalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="RentalID" DataSetColumn="RentalID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Zip_CodeTableAdapter" GeneratorDataComponentClassName="Zip_CodeTableAdapter" Name="Zip_Code" UserDataComponentName="Zip_CodeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DocsRoomManagementConnectionString (Settings)" DbObjectName="DocsRoomManagement.dbo.Zip_Code" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Zip_Code] WHERE (([Id] = @Original_Id) AND ([Code] = @Original_Code) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Zip_Code] ([Id], [Code], [CityID]) VALUES (@Id, @Code, @CityID);
SELECT Id, Code, CityID FROM Zip_Code WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Code, CityID FROM dbo.Zip_Code</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Zip_Code] SET [Id] = @Id, [Code] = @Code, [CityID] = @CityID WHERE (([Id] = @Original_Id) AND ([Code] = @Original_Code) AND ((@IsNull_CityID = 1 AND [CityID] IS NULL) OR ([CityID] = @Original_CityID)));
SELECT Id, Code, CityID FROM Zip_Code WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="CityID" DataSetColumn="CityID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DocsRoomManagementDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="DocsRoomManagementDataSet" msprop:Generator_UserDSName="DocsRoomManagementDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="City" msprop:Generator_TableClassName="CityDataTable" msprop:Generator_TableVarName="tableCity" msprop:Generator_TablePropName="City" msprop:Generator_RowDeletingName="CityRowDeleting" msprop:Generator_RowChangingName="CityRowChanging" msprop:Generator_RowEvHandlerName="CityRowChangeEventHandler" msprop:Generator_RowDeletedName="CityRowDeleted" msprop:Generator_UserTableName="City" msprop:Generator_RowChangedName="CityRowChanged" msprop:Generator_RowEvArgName="CityRowChangeEvent" msprop:Generator_RowClassName="CityRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Geo_Data" msprop:Generator_TableClassName="Geo_DataDataTable" msprop:Generator_TableVarName="tableGeo_Data" msprop:Generator_TablePropName="Geo_Data" msprop:Generator_RowDeletingName="Geo_DataRowDeleting" msprop:Generator_RowChangingName="Geo_DataRowChanging" msprop:Generator_RowEvHandlerName="Geo_DataRowChangeEventHandler" msprop:Generator_RowDeletedName="Geo_DataRowDeleted" msprop:Generator_UserTableName="Geo_Data" msprop:Generator_RowChangedName="Geo_DataRowChanged" msprop:Generator_RowEvArgName="Geo_DataRowChangeEvent" msprop:Generator_RowClassName="Geo_DataRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Xaxis" msprop:Generator_ColumnVarNameInTable="columnXaxis" msprop:Generator_ColumnPropNameInRow="Xaxis" msprop:Generator_ColumnPropNameInTable="XaxisColumn" msprop:Generator_UserColumnName="Xaxis" type="xs:int" />
              <xs:element name="Yaxis" msprop:Generator_ColumnVarNameInTable="columnYaxis" msprop:Generator_ColumnPropNameInRow="Yaxis" msprop:Generator_ColumnPropNameInTable="YaxisColumn" msprop:Generator_UserColumnName="Yaxis" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Picture" msprop:Generator_TableClassName="PictureDataTable" msprop:Generator_TableVarName="tablePicture" msprop:Generator_TablePropName="Picture" msprop:Generator_RowDeletingName="PictureRowDeleting" msprop:Generator_RowChangingName="PictureRowChanging" msprop:Generator_RowEvHandlerName="PictureRowChangeEventHandler" msprop:Generator_RowDeletedName="PictureRowDeleted" msprop:Generator_UserTableName="Picture" msprop:Generator_RowChangedName="PictureRowChanged" msprop:Generator_RowEvArgName="PictureRowChangeEvent" msprop:Generator_RowClassName="PictureRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RentalID" msprop:Generator_ColumnVarNameInTable="columnRentalID" msprop:Generator_ColumnPropNameInRow="RentalID" msprop:Generator_ColumnPropNameInTable="RentalIDColumn" msprop:Generator_UserColumnName="RentalID" type="xs:int" minOccurs="0" />
              <xs:element name="FileName" msprop:Generator_ColumnVarNameInTable="columnFileName" msprop:Generator_ColumnPropNameInRow="FileName" msprop:Generator_ColumnPropNameInTable="FileNameColumn" msprop:Generator_UserColumnName="FileName" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Rental" msprop:Generator_TableClassName="RentalDataTable" msprop:Generator_TableVarName="tableRental" msprop:Generator_TablePropName="Rental" msprop:Generator_RowDeletingName="RentalRowDeleting" msprop:Generator_RowChangingName="RentalRowChanging" msprop:Generator_RowEvHandlerName="RentalRowChangeEventHandler" msprop:Generator_RowDeletedName="RentalRowDeleted" msprop:Generator_UserTableName="Rental" msprop:Generator_RowChangedName="RentalRowChanged" msprop:Generator_RowEvArgName="RentalRowChangeEvent" msprop:Generator_RowClassName="RentalRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:int" minOccurs="0" />
              <xs:element name="Room" msprop:Generator_ColumnVarNameInTable="columnRoom" msprop:Generator_ColumnPropNameInRow="Room" msprop:Generator_ColumnPropNameInTable="RoomColumn" msprop:Generator_UserColumnName="Room" type="xs:int" minOccurs="0" />
              <xs:element name="YearOfConstruction" msprop:Generator_ColumnVarNameInTable="columnYearOfConstruction" msprop:Generator_ColumnPropNameInRow="YearOfConstruction" msprop:Generator_ColumnPropNameInTable="YearOfConstructionColumn" msprop:Generator_UserColumnName="YearOfConstruction" type="xs:int" minOccurs="0" />
              <xs:element name="Zip_Code" msprop:Generator_ColumnVarNameInTable="columnZip_Code" msprop:Generator_ColumnPropNameInRow="Zip_Code" msprop:Generator_ColumnPropNameInTable="Zip_CodeColumn" msprop:Generator_UserColumnName="Zip_Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="What" msprop:Generator_ColumnVarNameInTable="columnWhat" msprop:Generator_ColumnPropNameInRow="What" msprop:Generator_ColumnPropNameInTable="WhatColumn" msprop:Generator_UserColumnName="What" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RegistrationDate" msprop:Generator_ColumnVarNameInTable="columnRegistrationDate" msprop:Generator_ColumnPropNameInRow="RegistrationDate" msprop:Generator_ColumnPropNameInTable="RegistrationDateColumn" msprop:Generator_UserColumnName="RegistrationDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" msprop:Generator_UserColumnName="CityID" type="xs:int" minOccurs="0" />
              <xs:element name="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Street" msprop:Generator_TableClassName="StreetDataTable" msprop:Generator_TableVarName="tableStreet" msprop:Generator_TablePropName="Street" msprop:Generator_RowDeletingName="StreetRowDeleting" msprop:Generator_RowChangingName="StreetRowChanging" msprop:Generator_RowEvHandlerName="StreetRowChangeEventHandler" msprop:Generator_RowDeletedName="StreetRowDeleted" msprop:Generator_UserTableName="Street" msprop:Generator_RowChangedName="StreetRowChanged" msprop:Generator_RowEvArgName="StreetRowChangeEvent" msprop:Generator_RowClassName="StreetRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nr" msprop:Generator_ColumnVarNameInTable="columnNr" msprop:Generator_ColumnPropNameInRow="Nr" msprop:Generator_ColumnPropNameInTable="NrColumn" msprop:Generator_UserColumnName="Nr" type="xs:int" minOccurs="0" />
              <xs:element name="File" msprop:Generator_ColumnVarNameInTable="columnFile" msprop:Generator_ColumnPropNameInRow="File" msprop:Generator_ColumnPropNameInTable="FileColumn" msprop:Generator_UserColumnName="File" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Street_Map_City" msprop:Generator_TableClassName="Street_Map_CityDataTable" msprop:Generator_TableVarName="tableStreet_Map_City" msprop:Generator_TablePropName="Street_Map_City" msprop:Generator_RowDeletingName="Street_Map_CityRowDeleting" msprop:Generator_RowChangingName="Street_Map_CityRowChanging" msprop:Generator_RowEvHandlerName="Street_Map_CityRowChangeEventHandler" msprop:Generator_RowDeletedName="Street_Map_CityRowDeleted" msprop:Generator_UserTableName="Street_Map_City" msprop:Generator_RowChangedName="Street_Map_CityRowChanged" msprop:Generator_RowEvArgName="Street_Map_CityRowChangeEvent" msprop:Generator_RowClassName="Street_Map_CityRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StreetId" msprop:Generator_ColumnVarNameInTable="columnStreetId" msprop:Generator_ColumnPropNameInRow="StreetId" msprop:Generator_ColumnPropNameInTable="StreetIdColumn" msprop:Generator_UserColumnName="StreetId" type="xs:int" />
              <xs:element name="CityId" msprop:Generator_ColumnVarNameInTable="columnCityId" msprop:Generator_ColumnPropNameInRow="CityId" msprop:Generator_ColumnPropNameInTable="CityIdColumn" msprop:Generator_UserColumnName="CityId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="First_Name" msprop:Generator_ColumnVarNameInTable="columnFirst_Name" msprop:Generator_ColumnPropNameInRow="First_Name" msprop:Generator_ColumnPropNameInTable="First_NameColumn" msprop:Generator_UserColumnName="First_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_Name" msprop:Generator_ColumnVarNameInTable="columnLast_Name" msprop:Generator_ColumnPropNameInRow="Last_Name" msprop:Generator_ColumnPropNameInTable="Last_NameColumn" msprop:Generator_UserColumnName="Last_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RegisterSince" msprop:Generator_ColumnVarNameInTable="columnRegisterSince" msprop:Generator_ColumnPropNameInRow="RegisterSince" msprop:Generator_ColumnPropNameInTable="RegisterSinceColumn" msprop:Generator_UserColumnName="RegisterSince" type="xs:dateTime" />
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tel_number" msprop:Generator_ColumnVarNameInTable="columnTel_number" msprop:Generator_ColumnPropNameInRow="Tel_number" msprop:Generator_ColumnPropNameInTable="Tel_numberColumn" msprop:Generator_UserColumnName="Tel_number" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="UserGroup" msprop:Generator_ColumnVarNameInTable="columnUserGroup" msprop:Generator_ColumnPropNameInRow="UserGroup" msprop:Generator_ColumnPropNameInTable="UserGroupColumn" msprop:Generator_UserColumnName="UserGroup">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CityId" msprop:Generator_ColumnVarNameInTable="columnCityId" msprop:Generator_ColumnPropNameInRow="CityId" msprop:Generator_ColumnPropNameInTable="CityIdColumn" msprop:Generator_UserColumnName="CityId" type="xs:int" minOccurs="0" />
              <xs:element name="WishListId" msprop:Generator_ColumnVarNameInTable="columnWishListId" msprop:Generator_ColumnPropNameInRow="WishListId" msprop:Generator_ColumnPropNameInTable="WishListIdColumn" msprop:Generator_UserColumnName="WishListId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WishList" msprop:Generator_TableClassName="WishListDataTable" msprop:Generator_TableVarName="tableWishList" msprop:Generator_TablePropName="WishList" msprop:Generator_RowDeletingName="WishListRowDeleting" msprop:Generator_RowChangingName="WishListRowChanging" msprop:Generator_RowEvHandlerName="WishListRowChangeEventHandler" msprop:Generator_RowDeletedName="WishListRowDeleted" msprop:Generator_UserTableName="WishList" msprop:Generator_RowChangedName="WishListRowChanged" msprop:Generator_RowEvArgName="WishListRowChangeEvent" msprop:Generator_RowClassName="WishListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="RentalID" msprop:Generator_ColumnVarNameInTable="columnRentalID" msprop:Generator_ColumnPropNameInRow="RentalID" msprop:Generator_ColumnPropNameInTable="RentalIDColumn" msprop:Generator_UserColumnName="RentalID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Zip_Code" msprop:Generator_TableClassName="Zip_CodeDataTable" msprop:Generator_TableVarName="tableZip_Code" msprop:Generator_TablePropName="Zip_Code" msprop:Generator_RowDeletingName="Zip_CodeRowDeleting" msprop:Generator_RowChangingName="Zip_CodeRowChanging" msprop:Generator_RowEvHandlerName="Zip_CodeRowChangeEventHandler" msprop:Generator_RowDeletedName="Zip_CodeRowDeleted" msprop:Generator_UserTableName="Zip_Code" msprop:Generator_RowChangedName="Zip_CodeRowChanged" msprop:Generator_RowEvArgName="Zip_CodeRowChangeEvent" msprop:Generator_RowClassName="Zip_CodeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" type="xs:int" />
              <xs:element name="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" msprop:Generator_UserColumnName="CityID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:City" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Geo_Data_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Geo_Data" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Picture_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Picture" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Rental_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Rental" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Street_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Street" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Street_Map_City_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Street_Map_City" />
      <xs:field xpath="mstns:StreetId" />
      <xs:field xpath="mstns:CityId" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="WishList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WishList" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Zip_Code_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Zip_Code" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Geo_Data_Street" msdata:parent="Street" msdata:child="Geo_Data" msdata:parentkey="Id" msdata:childkey="Id" msprop:Generator_UserChildTable="Geo_Data" msprop:Generator_ChildPropName="GetGeo_DataRows" msprop:Generator_UserRelationName="FK_Geo_Data_Street" msprop:Generator_RelationVarName="relationFK_Geo_Data_Street" msprop:Generator_UserParentTable="Street" msprop:Generator_ParentPropName="StreetRow" />
      <msdata:Relationship name="FK_Picture_Rental" msdata:parent="Rental" msdata:child="Picture" msdata:parentkey="Id" msdata:childkey="RentalID" msprop:Generator_UserChildTable="Picture" msprop:Generator_ChildPropName="GetPictureRows" msprop:Generator_UserRelationName="FK_Picture_Rental" msprop:Generator_RelationVarName="relationFK_Picture_Rental" msprop:Generator_UserParentTable="Rental" msprop:Generator_ParentPropName="RentalRow" />
      <msdata:Relationship name="FK_Rental_Rental" msdata:parent="Users" msdata:child="Rental" msdata:parentkey="Id" msdata:childkey="UserId" msprop:Generator_UserChildTable="Rental" msprop:Generator_ChildPropName="GetRentalRows" msprop:Generator_UserRelationName="FK_Rental_Rental" msprop:Generator_RelationVarName="relationFK_Rental_Rental" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRow" />
      <msdata:Relationship name="FK_Street_Map_City_City" msdata:parent="City" msdata:child="Street_Map_City" msdata:parentkey="Id" msdata:childkey="CityId" msprop:Generator_UserChildTable="Street_Map_City" msprop:Generator_ChildPropName="GetStreet_Map_CityRows" msprop:Generator_UserRelationName="FK_Street_Map_City_City" msprop:Generator_ParentPropName="CityRow" msprop:Generator_RelationVarName="relationFK_Street_Map_City_City" msprop:Generator_UserParentTable="City" />
      <msdata:Relationship name="FK_Street_Map_City_Street" msdata:parent="Street" msdata:child="Street_Map_City" msdata:parentkey="Id" msdata:childkey="StreetId" msprop:Generator_UserChildTable="Street_Map_City" msprop:Generator_ChildPropName="GetStreet_Map_CityRows" msprop:Generator_UserRelationName="FK_Street_Map_City_Street" msprop:Generator_ParentPropName="StreetRow" msprop:Generator_RelationVarName="relationFK_Street_Map_City_Street" msprop:Generator_UserParentTable="Street" />
      <msdata:Relationship name="FK_User_City" msdata:parent="City" msdata:child="Users" msdata:parentkey="Id" msdata:childkey="CityId" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="FK_User_City" msprop:Generator_ParentPropName="CityRow" msprop:Generator_RelationVarName="relationFK_User_City" msprop:Generator_UserParentTable="City" />
      <msdata:Relationship name="FK_User_WishList" msdata:parent="WishList" msdata:child="Users" msdata:parentkey="Id" msdata:childkey="WishListId" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="FK_User_WishList" msprop:Generator_RelationVarName="relationFK_User_WishList" msprop:Generator_UserParentTable="WishList" msprop:Generator_ParentPropName="WishListRow" />
      <msdata:Relationship name="FK_WishList_Rental" msdata:parent="Rental" msdata:child="WishList" msdata:parentkey="Id" msdata:childkey="RentalID" msprop:Generator_UserChildTable="WishList" msprop:Generator_ChildPropName="GetWishListRows" msprop:Generator_UserRelationName="FK_WishList_Rental" msprop:Generator_ParentPropName="RentalRow" msprop:Generator_RelationVarName="relationFK_WishList_Rental" msprop:Generator_UserParentTable="Rental" />
      <msdata:Relationship name="FK_Zip_Code_City" msdata:parent="City" msdata:child="Zip_Code" msdata:parentkey="Id" msdata:childkey="CityID" msprop:Generator_UserChildTable="Zip_Code" msprop:Generator_ChildPropName="GetZip_CodeRows" msprop:Generator_UserRelationName="FK_Zip_Code_City" msprop:Generator_ParentPropName="CityRow" msprop:Generator_RelationVarName="relationFK_Zip_Code_City" msprop:Generator_UserParentTable="City" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>